﻿CREATE TABLE [common].[Company] (
    [Id]        BIGINT          IDENTITY (1, 1) NOT NULL,
    [Code]      NVARCHAR (16)   NOT NULL,
    [Name]      NVARCHAR (128)  NOT NULL,
    [LastSale]  DECIMAL (19, 6) NULL,
    [MarketCap] DECIMAL (19, 6) NULL,
    [IPOYear]   DATE            NULL,
    [Sector]    NVARCHAR (128)  NULL,
    [Industry]  NVARCHAR (128)  NULL,
    [QuoteUrl]  NVARCHAR (2048) NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);

